To Create a Datasource

Open eB System Management Console (Start > All Programs > Bentley > eB > eB System Management Console).
In the Explorer pane, under the Servers node, expand your server.
Right-click the Data Sources node and select Add DataSource.
When Datasource Wizard opens, click Next.
On the Select Database Type page, select the Microsoft SQL Server driver and click Next.
On the Select Server page, in the Database Server field, enter the name of the Application server database machine and click Next.
On the Login Information page, enter the user name and password of the database account used to log in to the selected SQL Server instance, or if database account is a Windows account select Use Windows Authentication, and click Next.

Note: It is recommended that you use the public DNS name of the App Server Database.
On the Select Database page, select the database you created for eB and click Next.
On the eB Data Source Name page, enter a name for the new eB datasource and click Next.

The name of the selected database is automatically supplied as the default name for the datasource. You can keep these names the same, or you can enter a new name for the datasource.

It is recommended that you only use letters and numbers in the datasource name, and that you do not use any special characters. While it is best to avoid all special characters, these characters in particular are known to cause problems:
Note: % . _ < >
On the Ready page, click Finish.
On the Finished page, click Close.

The new datasource is added under the Data Sources node.
Select the new datasource.
A dialog opens to inform you that the database used by this datasource needs to be updated.
Click Yes.

The datasource expands in the Explorer pane with the Database Scripts item already selected.

In the content pane, the Core database package is already selected.
In the content pane, in the Update Status section, click the link, Click to Start the Database Update.
When the database update is complete, click OK.

Note: The database update creates a log file which you can review by expanding your datasource in the Explorer pane and selecting Database Logs. There should be no error messages in the log file. If upgrading, error messages may be expected due to the nature of the upgrade. If you are not sure what the error message means, file a service ticket at .

Note: You can select a datasource and click the Test Connection icon

on the toolbar to verify the connection to the database. If the system fails to connect to the datasource, double-check that you are using the correct server name, database name, user name and password. If not, return to step 1 of this procedure and redo this process.